MICROSOFT CERTIFIED DATABASE ADMINISTRATOR 2003/ SQL SERVER 2000 MCDBA CURRICULUM

  1. Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
  2. Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
  3. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
  4. Microsoft SQL Server 2000 Enterprise Edition

I. Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment

  • Basic Concepts
    • 1.25 Hours

  • Managing Users, Groups and Computers
    • 2.75 Hours

  • Managing Resource Access
    • 3 Hours

  • Managing Hardware, Disks and Logical Devices
    • 2.75 Hours

  • Managing the Server Environment
    • 3.75 Hours

  • Managing Disaster Recovery
    • 2.25 Hours


    II. Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

  • Planning the Network Infrastructure
    • 3.75 Hours

  • Planning for Name Resolution
    • 3 Hours

  • Implementing Routing and Remote Access
    • 3 Hours

  • Planning for Network Availability
    • 2 Hours

  • Planning Server Roles and Server Security
    • 2.75 Hours

  • Planning a Security Infrastructure
    • 3 Hours


    III. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
    • 1.75 Hours

  • Installing, Configuring and Upgrading SQL Server 2000
    • 2 Hours

  • SQL Server 2000 Databases
    • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
    • 1.50 Hours

  • Security in a Microsoft SQL Server 2000 Environment
    • 2 Hours

  • Managing SQL Server 2000 Databases
    • 2.75 Hours

  • Backing Up SQL Server 2000 Databases
    • 2.25 Hours

  • Restoring SQL Server 2000 Databases
    • 1.75 Hours

  • SQL Server 2000 Replication
    • 1.75 Hours

  • Monitoring SQL Server 2000 Performance
    • 1.50 Hours

  • SQL Server 2000 High Availability
    • 1 Hour

  • SQL Server 2000, XML and the Web
    • 1.50 Hours


    IV. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
    • 1.75 Hours

  • SQL Server 2000 Databases
    • 1.75 Hours

  • Designing and Implementing Security in SQL Server 2000
    • 1.25 Hours

  • The SQL Server 2000 Logical Data Model
    • 2.50 Hours

  • Using T-SQL in SQL Server 2000
    • 3 Hours

  • SQL Server 2000 Indexes
    • 2 Hours

  • SQL Server 2000 Programming and Business Logic
    • 2.75 Hours

  • SQL Server 2000 Transactions and Distributed Data
    • 1.75 Hours

  • Analyzing and Optimizing SQL Server 2000 Queries
    • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
    • 1.50 Hours

  • SQL Server 2000, XML and the Web
    • 1.50 Hours